SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweDocumentacionMovimientosPendientes
AS
SELECT     IdDocumentacionMovimientos AS ID, IdDocumentacion, FechaEntrada, Origen, FechaSalida, Destino, Observaciones, FechaReingreso
FROM         dbo.tb_DocumentacionMovimientos
WHERE     (FechaSalida IS NULL)
GO
GRANT SELECT ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [GestionDespacho]
GRANT INSERT ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [GestionDespacho]
GRANT DELETE ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [GestionDespacho]
GRANT UPDATE ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [GestionDespacho]
GRANT SELECT ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [Informatica]
GRANT INSERT ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [Informatica]
GRANT DELETE ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [Informatica]
GRANT UPDATE ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [Informatica]
GRANT SELECT ON  [dbo].[vweDocumentacionMovimientosPendientes] TO [SoloVer]
GO
